Create Street Matrix

Step 1: Select the Matrix Visual

                 a. Rows = Street, Day of Week, Time by Hour

                 b. Values = Count of Crimes (rename to Crime Count), Shooting Involved Crimes (rename to Shooter Involved Crimes)

                 c. Select formatting, in general X position = 11, Y position = 77, Width = 508, Height = 320




                 d. Column headers, font color = black, background = light gray, font = Constantia, text size = 10

                 e. Row headers, font color = black, background color = white, font = Constantia, text size = 10

                 f. Values, font color = black and background color = white, font = Constantia, text size = 10

                g. Grand total, color black, font = Constantia, Background = white, text size = 10





                h. Conditional formatting, background color on, select advanced controls, format as below.



                 i. Conditional formatting Shooter Involved Crimes, back ground color on, advanced controls. See below.



                 j. Border = dark gray, sort the matrix by Crime count descending







Learn how to conditionally format a matrix by viewing the link below.


Matrix conditionally formatting